package com.bgIntlgn.client.entity.warehourse;

import yuhuibear.poat.annotations.relation.View;
import yuhuibear.poat.object.bean.Bean;

/**
 * 用户快速得到库存量的产品视图
 * 
 * @author yuhui
 * !!! 视图不写 Reader !!!
 */
@View(name = "element_stocks", 
		sqlToCreate = "select es.element_id as element_id, sum(uid_stocks.quantity)  as quantity " +
				"from uid_stocks, element_subversions as es " +
				"where es.uid = uid_stocks.uid " +
				"group by es.element_id;")
public class ElementStock implements Bean {

	private Long elementId;
	private Integer quantity;

	public Long getElementId() {
		return this.elementId;
	}

	public void setElementId(Long elementId) {
		this.elementId = elementId;
	}

	public Integer getQuantity() {
		return this.quantity;
	}

	public void setQuantity(Integer quantity) {
		this.quantity = quantity;
	}
}
